if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_LoaiCongNo_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_LoaiCongNo_Update]
GO
CREATE PROC [sp_LoaiCongNo_Update]
	@ID						int,
	@Ten					nvarchar(50),	
	@Ghi_chu					nvarchar(100)

AS
BEGIN
	DECLARE @Ngay_cap_nhat_cuoi datetime
	SET @Ngay_cap_nhat_cuoi = getdate()
	UPDATE LoaiCongNo
		SET			Ten=@Ten,					
					Ghi_chu=@Ghi_chu,
					Ngay_cap_nhat_cuoi=@Ngay_cap_nhat_cuoi
		WHERE ID=@id
END
